SQL: Create Your Own Database FAST! The Most Important and Core Functions to Mastering SQL by Gary Mitnick

Author:Gary Mitnick [Mitnick, Gary]
Language: eng
Format: azw3
Published: 2017-04-23T04:00:00+00:00

WHILE booleanExpression

SQL_statement1 | statementBlock1

BREAK

SQL_statement2 | statementBlock2

Continue

SQL_statement3 | statementBlock3

CASE

When you have to evaluate a number of conditions and a number of answers you can use the CASE statement. The decision making is carried out with the initial SELECT or an UPDATE statement. Then a CASE expression (not a statement) is stated, after which you need to determine with a WHEN clause. You can use a CASE statement as part of a SELECT, UPDATE or INSERT statement.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.